Hello Everyone,

recently I've noticed that while trying to run Excel files with macros I get the message: "Compile error in hidden module: frmAutoUpdate". Now I am not quite sure, but before that, I have installed some updates (highly possible, that this might be the cause).

I tired to google it and found following topics:

https://msdn.microsoft.com/en-us/library/office/gg251410.aspx  

http://forums.augi.com/showthread.php?141951-Microsoft-Visual-Basic-Compile-error-in-hidden-module-ThisDrawing

I have tried to solve it by myself: enabling/disabling Macros, restoring Excel settings to default in registry editor. Tried also command lines:

regsvr32 -u c:\windows\syswow64\mscomctl.ocx
regsvr32 c:\windows\syswow64\mscomctl.ocx

Unfortunately with no luck...

If someone is reading this, please help!

____________________________

I am working on Windows 7 Professional x64/ MS Office 2013 Standard.

Hi Nate162,

Please try this possible solution:

1. Close Excel
2. Open Windows Explorer
3. In the Windows Explorer address bar, type %appdata%
   and press Enter
4. In the resulting list of subfolders, find and open the Microsoft folder
5. In the Microsoft folder, find and open the Forms subfolder
6. In the Forms folder, rename or delete the following two files (if they are present): 
   • comctllib.exd
   • mscomctllib.exd
7. Open Excel (it will automatically recreate the aforementioned files as it needs them)

In additional, this error >>Compile Error in hidden module: frmAutoUpdate<< is usually pop up when code compilation Thus, we might need to debug code, I recommend you post the question to MSDN forum:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

Regards,